SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564227 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564227 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008311,315484,962810,264026,767962,423327,421596,764165,119650,423269,437211,813271,210542,631340,351878,815384,168306,725459,126536,680630,859334,970536,292267,497468,896234,93937,970918,960907,571251,536324,851999,457859,2668,464149,253394,322940,727742,213905,398817,703003,468479,561495,178554,251955,230119,405493,838558,267180,374508,286948,398581,689910,89488,142497,681311,93333,716723,898004,1023537,927389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]