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` = 110688 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110688 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984321,32951,978175,151990,546029,798211,404335,838779,458927,781368,771950,428608,85650,683895,857069,821643,632570,616546,702450,1021543,147638,7427,495426,1046366,159963,1000577,684456,891508,694575,243480,533129,272170,288556,381188,809141,582244,238950,351604,987460,96479,940650,685791,508528,866239,42214,25046,207016,328102,112163,804315,113929,959129,380671,78168,768102,616924,900067,661086,176905,817467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]