SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 136101 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 136101 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561783,248304,1019174,914634,142178,63161,466624,608076,87953,603073,827952,692472,932212,445025,106748,954106,105688,812530,564683,819047,511695,216788,157664,697350,1044065,1038860,493904,266701,878742,545576,680361,79177,619208,201786,150800,999347,1022870,449218,70161,834005,676620,801527,396504,699569,574604,621037,648533,107643,313678,322750,885841,156082,692815,125139,151685,320706,709296,794665,22711,857586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 136101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 136101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]