SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100103 LIMIT 1 [ RunTime:0.002055s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100103 [ RunTime:0.002690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133790,892717,306202,344449,836513,300714,462900,989836,50047,816620,877598,176091,121225,1040453,255622,420516,32704,845070,665698,953430,625209,601640,852571,730143,119754,595837,4236,748205,480755,160804,899967,612888,337033,633529,523540,317863,1021257,608304,191179,930006,179276,255191,658422,955607,875065,959588,758990,605825,824676,182302,153330,463999,760732,840294,762096,488886,972773,498741,123983,298366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]