SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55142 LIMIT 1 [ RunTime:0.000675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55142 [ RunTime:0.010337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492566,501636,955321,975626,959252,772991,306955,1045349,578314,109966,901347,226864,336722,627328,610694,504917,661741,193419,292195,331191,1020441,573183,907923,238469,53152,796373,915804,758477,191830,588042,774570,439566,132632,639892,393137,80047,991180,923372,787705,922283,182189,208077,77799,807592,590524,366447,345222,410927,19399,316446,993317,54352,667949,772997,710156,910781,291083,316394,754587,530105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]