SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505304 LIMIT 1 [ RunTime:0.000695s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505304 [ RunTime:0.007411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137830,884683,120645,444502,383725,744769,950301,612585,481641,505406,636636,299272,550061,640200,614635,921591,225823,713380,319686,538060,1025337,539092,521025,674138,535847,665903,266130,306955,837883,478110,134392,475912,95607,856242,980758,674817,42942,570186,278081,6406,173685,803677,445164,716742,335331,986039,808017,452678,952227,393652,458,423298,443203,946483,193294,1045771,124066,221150,592187,805779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]