SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280843 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280843 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984183,307933,665907,548548,326659,111119,921559,283115,484890,558729,860040,436218,535284,194486,435646,476747,599065,771127,530079,809424,724214,29808,124872,802418,1015637,828586,657554,639994,924787,82246,685917,316124,625053,384076,743838,253367,508697,781611,198244,664652,1018745,868333,924269,114132,160394,325174,998407,299372,904816,467909,908828,105067,29821,656496,898936,485502,740632,642877,956425,545337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]