SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465052 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465052 [ RunTime:0.002391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594338,935457,159547,1002043,999736,885047,987478,42032,152883,155249,140195,204232,16303,1012569,37551,337392,1036027,95510,905230,329056,761328,562652,476137,572416,55260,868461,372508,200476,24434,374750,760117,276918,111679,440031,225035,791391,1033801,320619,883726,434875,194557,74285,385703,1005470,34887,58636,595540,1011006,442760,766505,891306,650432,943171,312533,695119,1042666,92809,130541,241577,144143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]