SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102012 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102012 [ RunTime:0.003268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820297,335926,748741,874183,264033,635491,18884,649163,308100,991660,44208,640690,283109,537641,211781,740927,190285,1047200,91009,743703,77887,6896,366317,931623,645942,570832,639341,91711,906164,791938,884812,944723,23941,756121,470935,659163,247050,781258,305717,112936,915723,369862,1048182,571537,28230,234414,600855,906025,606701,211059,642932,645730,133803,787660,1008232,229113,116227,486405,809501,197457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]