SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555416 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555416 [ RunTime:0.003968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285045,667038,140524,132107,306149,100431,166534,969016,639452,276516,460500,42837,523282,562440,755647,329896,235086,25184,646171,452984,264151,465960,401502,1012006,894235,321802,653119,477028,765680,309184,739602,13116,601404,788575,589846,812915,259864,574702,270322,907095,717315,893475,584751,502188,722692,457052,664794,20258,95574,331209,67168,414599,176599,303036,682955,285599,787670,227739,437961,984976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.010247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]