SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570964 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570964 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802322,719650,781814,49821,904833,955141,682410,861995,867696,467944,24017,975953,127606,490639,70410,23525,493231,573370,283561,312163,599431,773969,557380,258168,758072,420143,29141,899662,211636,276386,879425,1013251,368287,1039994,1023347,469783,13480,830424,517850,971621,958800,709775,875243,340563,309229,560178,209575,16519,220310,809956,632120,251807,606677,737636,319562,75137,823173,1042401,622266,539087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]