SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422028 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422028 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86100,837834,454821,790658,956238,510273,174959,717067,710881,436202,917462,799417,396060,999564,365682,435329,283182,811279,131754,847142,146130,154002,776920,966901,133071,976610,128193,602263,818969,726393,363556,455171,1006795,966280,677807,236408,97587,252749,92283,923156,57235,535060,120688,893111,1008779,113471,1024568,989893,73806,590153,295782,1030828,832845,15172,936853,650090,187405,846147,71765,169757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]