SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507594 LIMIT 1 [ RunTime:0.000901s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507594 [ RunTime:0.002701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535838,85217,482832,767924,785583,875924,787221,135246,411526,988582,519553,355887,38033,257661,220114,353848,1032503,139301,6745,402118,233462,369846,543350,51230,204589,571826,343159,955405,798547,410116,145677,919445,779857,760616,217394,871636,384562,159435,903966,417011,63449,588377,868991,996076,870847,393757,476793,458878,886532,655529,490285,462448,836596,64705,813730,286053,1009181,32658,814384,780448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]