SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443712 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443712 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298213,391630,665579,159663,978346,491467,560369,641584,99829,1001236,318185,524615,800576,475442,398225,1027717,14747,585868,177253,43015,763764,149838,6389,607695,842909,286161,199012,653760,718240,972872,944636,168530,635531,279424,799484,1041535,56008,409385,750793,64018,402292,446840,266869,804676,706356,777048,279371,561315,9926,139552,661129,771055,57297,100821,160609,1048588,772949,992415,974470,784844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]