SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002644s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241968 LIMIT 1 [ RunTime:0.001374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241968 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437539,939949,558923,121377,1033411,72170,798912,384341,164396,614809,487749,235745,1035614,1001332,671143,644402,487076,48784,973737,916790,566986,720576,331597,1032576,196288,395357,248896,210515,546466,879009,936082,226003,484216,189529,77453,576019,7808,249520,777509,231932,302176,81384,957055,1030085,284564,725621,283000,652870,220220,673860,630501,176942,568671,874661,865841,386449,900731,904205,412027,266898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001901s ]