SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018086 LIMIT 1 [ RunTime:0.001039s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018086 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512161,378069,868806,667466,831779,605991,55188,687206,930317,1014233,276675,89439,842519,469057,408802,1039496,538629,117416,504987,954916,118453,723534,982554,375196,596265,855189,682391,165492,977051,468990,823343,869195,320221,212429,1029457,993320,533765,548053,465832,323148,418428,873017,824020,208796,850838,951619,286856,581040,813221,749048,926469,893083,113327,669885,617052,968669,664378,512248,485643,303989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000951s ]