SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491758 LIMIT 1 [ RunTime:0.000843s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491758 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593230,1041002,347373,19520,65635,392758,694013,348366,64830,737284,208462,263302,486955,362909,242877,766575,14666,894635,539308,331680,1037848,876099,185405,182781,896507,885470,140424,711922,781128,215771,769385,553466,324746,218746,596905,949024,30155,654204,243362,894492,822887,624137,70468,364176,1022187,526319,183297,1028213,832405,992317,170849,391102,321212,596456,668802,735334,533829,159399,173612,995187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]