SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431458 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431458 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585169,541682,861012,501087,242215,226857,771069,117452,371805,969937,516247,351938,101619,378000,971671,939419,512056,233962,1001469,558409,314373,742798,945672,938016,135822,850925,604561,468153,1039777,685916,727425,1045044,453892,219457,509549,855759,845091,375274,947986,703077,980203,465933,328324,655442,439932,1011186,944118,194767,115138,545811,668083,288707,409975,351434,506260,720763,817418,692805,716017,869254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]