SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520335 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520335 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839035,180734,439404,979393,337774,968144,962702,611169,576692,295462,813610,582385,689818,445233,31985,822549,409299,804987,807549,154942,265745,262786,644096,287310,691383,142776,376843,506097,889189,505191,788781,611457,1047957,984870,923276,142218,261315,579889,50896,978765,824085,733469,932183,313970,146337,331378,136,926972,174897,952319,877060,303750,334820,389348,527725,66827,382227,217558,990901,210630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001117s ]