SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445638 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445638 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119983,981820,439924,450521,468186,418855,143132,635434,308989,81418,605392,834290,639951,622942,645532,878298,416321,222678,308234,479644,1030189,669688,830347,346502,625024,759053,393352,872511,392108,420225,988421,983098,624133,275824,453204,71464,979854,487064,586540,660337,762727,201859,34503,390340,935644,143422,177977,1002204,215922,761091,370717,786187,933235,188313,835164,739954,735707,76670,782899,147159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]