SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801093 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801093 [ RunTime:0.002519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451270,403399,295775,1038231,81289,897349,848619,561189,954156,881556,657872,77596,901168,578132,313776,459240,1005928,133791,1046290,502677,564137,53348,827453,400406,179374,394017,132392,950595,224628,489788,30796,551208,871629,580807,407712,771079,1044595,288998,114645,1006832,533730,796605,785825,309361,507573,220060,791078,896009,207309,965628,817546,885848,280895,183184,439890,362078,918178,860369,261331,55926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]