SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029049 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029049 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108846,688168,265446,819082,328522,148538,31336,238576,416864,188067,628799,873818,724446,175953,101018,990234,345797,337358,416029,961723,200215,353906,954860,248942,408473,757599,821862,163828,519949,481661,229819,632136,242878,712267,113573,550542,278684,956160,180756,348906,849352,829482,520456,571450,159816,1036127,410558,191086,684083,165228,988857,418781,676353,845832,28182,594898,612799,136484,377877,794836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]