SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503922 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503922 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828645,1015649,128958,764285,967165,833888,15835,518162,505441,990078,203925,640008,1027517,906079,1024146,237425,927465,570132,191193,300948,153178,132336,742245,19782,1032381,742613,199443,272923,916612,732660,152582,409735,982989,960137,679474,314380,317126,946915,449543,836661,517658,623484,658469,728409,224714,387754,831965,518892,243339,979120,397003,751391,926517,944689,581802,985306,789598,588029,296050,1029383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]