SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003956s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519650 LIMIT 1 [ RunTime:0.005028s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519650 [ RunTime:0.008161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12222,732176,797958,955213,555687,94691,64015,442703,338652,939586,845666,534798,114352,220354,922772,97474,540684,389064,305160,953558,883501,898522,740333,193482,31802,740200,27190,105788,520888,786718,410431,115008,70073,686465,971882,467723,156860,517462,953335,898817,253287,749948,474273,321432,387392,569514,253058,211210,859826,1031615,600392,866672,455003,493697,911714,55708,42447,17774,420846,51253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]