SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305363 LIMIT 1 [ RunTime:0.001123s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305363 [ RunTime:0.003667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543618,263603,267700,843029,898255,214494,328537,831564,568343,39328,520687,739459,56851,140069,274530,369722,415805,236570,104551,1013051,1026508,276974,309419,331396,383611,181742,736820,635446,854914,199467,688527,629985,154630,118933,950552,925964,896400,312705,844371,950166,997539,460128,724448,415552,1001521,1045409,428472,464910,513920,152474,986293,265255,1024263,1046194,523386,35919,49918,93361,2305,597915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305363 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305363 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]