SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505414 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505414 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295597,781497,1015493,435269,24911,135241,776704,866031,298200,63828,367333,13830,1038826,460288,972576,179449,569881,411944,667564,240984,391730,31174,727939,860479,1000065,1011756,558643,601826,267357,764880,316875,471144,292790,207635,349230,11479,120877,275908,103239,556467,494763,788922,879985,282689,249090,738388,814088,895901,397548,475314,673541,895055,75452,862380,196508,687066,833273,217417,820300,861265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001985s ]