SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520685 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520685 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471544,561937,252355,203586,615832,471885,1032196,781582,201153,579742,913674,386528,321638,82618,290376,69773,1016083,616739,340302,597980,408515,403612,240426,56631,858348,346896,168804,655664,637707,377322,83639,102272,862305,448665,880071,496445,176793,304778,996221,74240,224125,1033321,121316,95019,302664,158003,666901,683755,235139,82606,527816,455198,156767,916610,87399,192713,771662,1391,248984,929155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]