SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004961 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004961 [ RunTime:0.003735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368824,787441,506494,1024913,1025721,414002,335294,346128,575586,395015,805287,99039,713905,270401,384647,939468,403648,30789,84942,702288,489174,501829,71619,246727,92077,984487,287082,941884,659429,66702,942076,897439,1012949,623571,588866,450100,276575,469181,934404,354999,603970,678094,903440,659076,119341,661373,514299,53105,688113,1042975,372364,891793,54158,518606,928442,774633,790258,582742,278328,609072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]