SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539502 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539502 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022302,179032,17146,243362,496565,271098,516396,1047840,670605,389080,232284,879279,987411,1001308,549941,986517,609130,180091,398329,56667,930577,816377,304706,716255,952788,665660,193690,375487,349499,582986,565138,132090,320561,460754,306001,279613,59708,400166,467001,527511,637711,367934,974996,456366,1035023,70475,274248,979938,877349,328795,397114,1029800,805051,595426,66713,1006290,227897,672894,399150,225458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001425s ]