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` = 1041511 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041511 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461444,931160,735047,541975,327821,472489,763298,784830,531324,464148,988473,176533,717494,548272,984635,344552,223747,995559,212307,364108,143229,182815,387657,223346,713819,649096,712415,85913,1032423,2328,971307,77319,987846,474371,2894,688007,144615,168844,227499,629354,41737,432886,589176,362758,408212,75322,622912,494892,43212,398355,336811,892562,285344,298470,435734,235757,938328,491132,25352,507690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]