SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498813 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498813 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971443,769781,898909,392795,932427,619118,591492,988749,14669,748334,447061,1020535,737788,730249,294978,502579,501205,941005,404014,960506,657231,504700,184136,547935,178092,150941,161918,438330,762416,810658,689745,668916,614392,698312,931859,537647,302604,968129,644147,417537,844938,793935,331746,121227,114626,714335,727557,434091,114181,188797,875022,455511,813742,443094,80143,380999,978473,444583,894047,725964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]