SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012189 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012189 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680869,1009988,495991,959662,755541,162282,828230,357818,503834,440928,509253,548790,306609,117058,405992,603505,635846,605149,325086,976885,254444,868177,1026452,781112,606782,974755,79750,284799,681959,680119,291752,783189,1002460,879379,225602,918485,1018003,283181,168818,928990,797159,539572,762797,448034,29925,196369,234215,185326,759489,488423,930778,998019,514742,498557,515741,773875,736824,485466,809019,412690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]