SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408563 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408563 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932029,436979,280753,124521,498479,184998,755663,788784,875680,587195,706005,89715,184484,215404,192304,883308,820879,959793,445477,277295,237494,182493,310418,198364,724112,500348,642836,1017587,459413,497459,1044655,74027,445860,49042,657450,94715,590218,226081,674117,468234,116502,411474,246510,485714,725406,227647,1026225,621069,43770,67279,220020,239369,48432,201059,204348,879011,1010083,72237,62713,152946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]