SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 234838 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 234838 [ RunTime:0.003824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719045,582952,906484,531083,108701,1022255,95429,578723,592775,634353,657487,375952,352798,1012992,532580,795514,174646,222482,842224,406714,292513,475067,520366,538011,546888,821033,654899,973794,965486,268290,1038026,964639,142148,597545,199122,747282,513189,472794,548031,717899,505489,1044091,397617,113619,926262,341920,810230,594760,88036,768642,1036811,334630,656054,993239,481405,593586,834105,18511,244224,575489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 234838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 234838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]