SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100366 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100366 [ RunTime:0.003369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043876,771134,485194,402378,79535,144997,576824,490637,619558,559146,1017585,487126,398791,922915,54313,745886,6791,575200,4077,1039904,778795,1026055,164640,445245,28044,204542,841729,360878,5360,915978,156766,352590,1024345,644099,997893,605264,474868,281352,784974,1019198,34456,1019892,962837,697977,150237,798608,985610,789836,67108,1047471,443926,893996,137589,313539,430185,513771,103708,663630,625511,766711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]