SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402319 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402319 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25415,278503,323989,325435,573037,110452,178734,740478,876009,284155,410620,572417,262752,162160,68161,936008,887377,979524,574139,1008354,786594,680972,744713,554685,807475,441739,146989,478213,685476,687419,192183,512534,130484,147962,147216,974234,248801,978417,1003183,34572,1004003,673596,65214,213143,699673,574251,238063,27752,828568,35594,493655,11068,399089,226944,352668,157636,241578,210163,131178,1017520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]