SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287413 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287413 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909902,811378,994255,906426,487287,195998,123609,813269,745545,205591,380879,297939,623906,447448,1025110,83596,548642,425536,227822,14878,646106,37569,759123,782581,239604,774065,690528,89852,755726,171828,162672,755046,615715,465127,801460,618940,713411,16557,406942,434704,728946,321730,434064,513916,866323,1006949,850617,148460,576434,12271,532832,977450,687619,760328,143923,329614,670195,656650,113250,379839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]