SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507415 LIMIT 1 [ RunTime:0.000271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507415 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614763,629150,209451,147933,1033366,1029820,518641,30399,203998,442426,749963,991763,1035076,354449,771524,592909,233025,671431,844041,180227,975073,606425,284439,123654,142093,332715,412287,455436,554793,633432,673914,92020,42728,41278,308878,972628,1045643,707616,165329,348844,574954,909788,446408,133700,442805,180248,155824,996708,796532,934223,119543,682547,293331,1036427,495429,337953,111512,358703,262938,860792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]