SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802813 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802813 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729847,600697,176144,954720,171748,479312,33556,544937,102507,907138,25522,275803,234956,617047,325203,566212,43770,273960,249898,848683,286978,856034,394383,426926,270003,984987,255953,805740,812536,464830,74448,179289,1044621,521466,82751,459696,19925,923330,705552,87369,738445,498267,152932,574689,853226,167597,964971,1032200,92490,829073,1020999,968715,1037667,623698,224240,775321,497523,454605,285338,63430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]