SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531109 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531109 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813835,316403,844375,524198,346162,629927,526496,570334,349105,582379,655541,373564,243047,527599,696159,217144,912813,247768,632687,466763,167520,1016340,24641,357505,313316,940677,224467,666449,519738,1037963,369914,735557,710980,516465,588888,866181,959486,641052,391794,273081,414411,1009298,834435,395326,252174,932933,914282,795021,97120,59401,14581,103983,621012,808778,439150,578082,980040,551144,471015,32608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]