SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451193 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451193 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824728,260340,787894,557966,195289,789854,163979,874384,354931,743017,964939,600657,698230,89380,107398,321240,20370,725867,397375,1020114,615301,1967,179881,400847,859495,930734,747872,894074,943189,849158,935843,175377,395384,410347,376941,678807,3867,889761,779204,391064,122633,773297,724161,711740,149686,773846,581746,293533,960437,987053,994117,275201,150619,472706,886354,737751,319792,857102,36216,196832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]