SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465881 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465881 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461918,159860,920549,387067,1046954,252781,601258,777110,409211,874722,39649,217301,1042854,540001,671125,885211,368390,1030307,275512,541099,659014,682772,532292,516079,1042084,224824,212731,94894,747144,27071,378095,832694,243097,357287,1016815,294025,384171,192688,130979,654221,71518,743419,619739,722349,410636,592892,574716,791761,153214,296597,101567,427996,174950,254501,375876,208190,6508,995201,696961,170095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]