SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401964 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401964 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696967,787926,170004,519026,317782,64272,770503,1043937,49752,713639,133093,144504,505110,225055,441901,143721,917904,896287,995758,928916,447315,488665,68952,598671,231781,200581,360083,70969,214150,567731,737120,714834,952919,829026,15068,27182,668422,829884,783054,724797,478259,57022,170519,106787,520382,629639,520436,148648,223262,440054,1020057,248893,601445,302889,971378,247053,12677,379284,826697,534578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]