SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 168028 LIMIT 1 [ RunTime:0.000883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 168028 [ RunTime:0.003372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520195,379834,193270,789519,539963,57435,310787,918395,181622,645460,18753,919563,524296,111036,616798,631884,258116,121578,760630,426404,907262,961960,760965,1044594,159008,1016927,960193,426834,1000433,115649,882560,131095,302106,731511,689882,1009763,1038482,119107,543933,781693,201170,1036604,820357,25111,450855,729515,717835,333082,493866,782313,66656,54775,80534,486627,936414,216839,855507,825855,603964,522892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 168028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 168028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]