SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 216713 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 216713 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446294,966587,518477,470863,216233,112938,522080,413653,614535,435605,535922,450010,356049,1037390,33052,957710,334684,1005167,126781,154198,156017,843470,547520,709363,518373,174033,491614,314540,346488,678554,1012382,923069,317442,588194,270818,994377,274101,763838,913616,242476,282708,200390,756328,254563,25404,135514,143747,113545,830094,549837,881097,168776,435231,464442,304387,346381,129872,610757,1031941,437383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 216713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 216713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]