SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48568 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48568 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272970,225734,595702,776681,867173,430785,808957,1040460,950960,145577,494988,13584,340335,199652,421716,526811,458211,699026,405421,502594,432050,125494,957197,727630,480440,501827,106528,25236,497831,60266,219236,636895,722869,916850,965698,619570,208903,343202,874624,984306,59387,192293,376223,180099,730670,474159,804771,10382,657175,357140,683575,132043,17627,642316,136718,542553,761172,907160,47475,35879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]