SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110143 LIMIT 1 [ RunTime:0.001271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110143 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573928,138272,709013,42310,840541,891195,812785,614,723039,156675,918423,465397,481948,679349,87597,183164,963527,650364,381997,450674,307550,568208,489391,237920,562082,773846,476515,633788,970680,26569,130872,315658,144621,695281,345279,673862,635720,407398,490279,470794,464211,709172,851984,266496,688917,522222,193848,601111,299848,374801,307803,509813,630076,205957,398285,752721,249807,624758,605084,379451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003832s ]