SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519516 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519516 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414398,215806,46153,266409,358672,346410,322625,357744,21186,359898,1014638,26134,803964,57516,745952,352587,855084,782188,677898,438427,420814,38896,456692,1015481,140845,646808,711228,638011,626277,468685,499399,25613,825555,663128,201112,188083,668435,379904,10456,706097,641782,291602,76487,344298,527031,836515,619532,705135,587295,704200,300496,423841,372772,847498,529582,346130,577156,285926,15416,361394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]