SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508251 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508251 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866243,906410,757136,190554,840491,290916,821437,382100,137372,862732,861917,345763,424703,327795,986159,451191,854976,489445,256484,594152,76356,450287,417886,629974,881505,601454,391095,550226,719464,93232,384668,272988,135389,479705,1016678,160987,86267,98936,297505,88483,668011,880188,667133,419748,777619,618607,620579,188315,144613,429961,505120,516500,941691,441395,714782,204201,144530,512950,509375,582151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]