SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114223 LIMIT 1 [ RunTime:0.000524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114223 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495157,1018008,16508,170787,320853,180026,846115,310404,118878,225019,290833,420506,6221,442517,1012338,636581,1003413,393017,455915,62076,289778,729064,894958,576551,671808,651221,197183,782469,109523,858637,530394,101000,247094,511226,751624,969696,1012091,350788,533484,84320,923899,216510,988012,113213,104995,788951,614214,295589,601750,37720,971685,412378,753134,4968,993994,128247,1014971,46291,970902,1011578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001113s ]