SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 688323 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 688323 [ RunTime:0.002597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37289,856540,595401,1037962,592517,267671,869805,321451,560733,108610,558885,804607,250043,541893,763100,251160,202528,1044013,614529,238722,190316,56411,207809,315565,768215,471107,411779,178242,401226,463797,984825,645979,172772,622952,754525,659675,315612,187065,800701,880485,54917,419695,665073,773677,825512,868977,309409,286390,516390,968883,306915,715231,898531,391627,123553,345742,452466,758735,868075,178931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 688323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 688323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]