SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436300 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436300 [ RunTime:0.002645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511972,660963,883634,988543,414553,123380,744403,123587,915251,846958,188471,58217,489124,70503,615908,349147,1004729,426639,530291,252923,355211,89366,305267,184731,1012370,1011619,334166,438483,206968,804861,609380,824742,76962,118908,283380,337708,223127,318105,626050,768787,255603,245436,373245,106903,353033,294804,929661,734952,566706,896645,928461,909781,412161,114223,157798,1039144,770399,906913,173258,338287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]