SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598913 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598913 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413860,214086,654469,148938,52306,363657,700556,475271,858127,716275,664893,158609,652704,526267,637105,38529,432269,456640,713005,372600,224533,1021472,333873,1022828,17089,698612,520249,962293,544267,524273,420366,628680,891420,704961,442042,660900,723800,536569,372148,981178,523897,32106,828388,831873,508085,213366,277322,340909,592980,702884,929181,720440,324130,519289,503681,972498,47118,92392,399939,712964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]