SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544972 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544972 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44387,842471,502003,980738,609441,13992,113917,643619,169590,589038,80447,747299,145826,686230,771773,262987,627,769635,340395,371070,382225,964595,577458,793856,524059,25640,704313,761620,656006,37810,613084,400366,198637,451392,667172,523712,1009392,397120,272871,201359,799469,582399,696500,145229,350218,64052,1010964,31097,901749,454556,40085,865514,228224,486091,420380,796076,400420,672532,429618,94068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]