SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10173 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10173 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814317,140830,139876,343340,719155,246145,1047891,732296,658673,315475,99044,641954,606763,802781,377049,1020036,899771,354326,417297,602857,847110,709742,836280,827603,161663,575590,777764,474661,266497,492088,653041,745782,120966,133344,159544,422919,251843,637400,909689,441501,982533,13286,294684,202202,537229,276771,523573,125549,317335,125876,750078,377876,674999,133158,384472,576869,54776,607481,781183,1019582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]