SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300320 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300320 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116160,437671,188417,119183,379212,784894,471476,440100,15888,596685,193258,339673,380709,932908,226921,24679,860153,970064,694292,603315,203527,98859,543131,175817,9312,291536,269818,318308,689117,683073,818542,498554,605434,541726,148954,791690,348654,301790,191039,872180,108900,1040646,433900,109758,298752,415883,695,882774,268640,793047,672180,932827,815455,273008,414741,762941,581755,652764,913634,844528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]