SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401716 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401716 [ RunTime:0.002592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9517,478508,434402,582430,821052,317295,653998,879540,272938,728977,988268,64725,601549,587552,436096,855883,30562,484889,730035,633546,865092,191839,266681,587354,755523,71158,295529,545954,223577,285186,306058,142588,1035923,392062,187287,808413,620194,627574,289680,404984,420952,523213,268231,103519,129627,398926,192132,371254,4178,971210,3644,655776,436012,744963,63765,739712,1027199,375987,343365,612257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]