SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40641 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40641 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193450,215456,571914,360727,737679,424305,3057,43216,337766,370278,959082,495850,184169,612698,294181,849026,682455,113071,987936,196560,1046498,636147,513244,985750,696023,978174,267391,457611,773174,252312,97306,220909,898589,880817,616343,336633,858190,752522,520643,176790,816868,719552,769440,251955,670034,932352,558652,190283,70524,860789,702902,529296,944623,489068,178793,253111,352067,289837,717575,362163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003096s ]