SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403385 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403385 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719216,276240,1045572,1012529,817979,527315,828945,893381,573419,498096,351674,282360,642591,40523,819540,763893,753802,807296,288169,457710,989469,696312,902279,537892,934865,655820,150503,212637,541991,768481,1045701,368468,545415,722377,999755,793324,65128,498574,893390,187560,174563,746121,15771,1037976,827139,661405,437452,694454,482543,1033321,338362,94729,789726,1044417,1046181,325372,1027831,935579,491297,100202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]