SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596190 LIMIT 1 [ RunTime:0.001773s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596190 [ RunTime:0.003018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428114,30843,875041,1001038,713043,590792,891437,710410,128609,1031673,487726,1021697,860856,915740,458365,410028,563811,838478,735535,389435,740564,247349,601838,922576,580667,251027,816294,271678,853802,152038,121304,404443,132331,881111,936351,919976,952728,930409,975573,485766,246194,629964,255548,588500,314529,11188,56984,1000586,87434,810661,33164,947155,452029,1021061,836226,1035423,61683,583016,132007,1039595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]