SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415370 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415370 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760216,570515,956085,229448,517987,171539,427414,634708,26324,1023403,353908,320401,261164,345988,324074,754327,381037,874859,78956,548528,882121,397583,250168,678254,163923,995786,927542,1045480,817790,442858,233364,320348,71882,1014821,189742,210289,771864,338324,502880,20452,482859,43876,756232,33736,24123,452643,570574,974849,1046354,796275,456509,301972,171900,969628,261589,784492,11860,978202,572966,266160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]