SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016476 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016476 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140347,523892,247993,31847,844924,424206,379389,520616,912984,224918,186484,147749,681073,458793,849895,50087,326045,532336,903059,883009,909150,942142,449081,258856,838869,264030,227193,34769,244832,607969,432156,708703,582279,845884,448638,639195,685724,838375,213149,516065,812404,302855,476638,856313,1002293,595568,953779,16956,915974,277674,411941,688683,765748,244133,1043831,908084,547322,96012,366004,81401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]