SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527838 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527838 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044091,293057,557055,1026806,695921,1005302,721224,875726,546751,965101,601453,53336,571132,321319,314767,902517,118820,674255,596628,301317,890848,283038,382484,1048011,72952,722492,398196,317715,613004,696269,313530,361323,931322,503521,210002,353806,458056,302604,338747,379729,332838,525647,939020,795056,803328,252485,526512,1016682,320312,248275,215938,61935,67395,307138,111190,925664,983983,22928,962270,163951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]