SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194877 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194877 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910963,50310,391177,350737,50084,508519,970988,810724,146575,45205,277836,1025513,1003487,405860,257924,1033097,611670,746974,536437,681189,161937,1041152,1043207,268111,960992,1014176,687304,164124,306117,311848,734578,738622,692331,136431,830610,682434,823307,85198,399074,492783,638236,879817,717651,895599,400490,539517,139083,755966,79580,639128,700563,912926,301165,835749,922676,539680,919999,477055,622864,108014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194877 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194877 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]