SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570722 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570722 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38217,815294,784535,236321,132951,362884,864772,964585,616752,612468,968651,597282,160668,121256,1031482,354057,799317,788851,564426,1026997,421380,699268,389524,134303,50877,681880,541367,422238,700077,42359,722817,498678,300592,159332,379838,854123,97940,513494,592383,722818,868942,465528,811933,218943,107596,738341,198963,810110,833251,766008,27459,849718,75136,838105,481508,56339,505960,452998,748404,763452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]