SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514191 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514191 [ RunTime:0.003259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282282,602319,50417,334763,157981,514958,260988,690917,196998,796677,680609,533871,862493,538763,355533,254987,1037736,669934,76572,610286,236167,824616,724193,263372,406494,736282,734339,437128,913486,35317,439339,248415,662273,814961,51203,854299,265029,322829,232735,380142,324602,105620,1024050,454790,232224,459150,955265,812022,441590,916578,191320,387625,579060,619307,905438,520970,914870,846267,176608,513978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]