SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503953 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503953 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348490,379738,66718,358600,45914,848283,449958,292096,934746,854875,1040852,357168,870856,849315,639334,85488,422224,795911,541541,886957,1015840,374396,98012,335675,153580,898816,491448,90595,331491,468451,843315,22505,562494,550370,899527,761994,99132,433812,552832,324604,126143,946974,897554,805390,878354,976356,541181,111305,1034589,448690,229046,322142,410780,988243,977921,315573,57607,878586,693571,409708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]